CREATE TABLE [dbo].[Contacts](
          [Id] [int] IDENTITY(1,1) NOT NULL,
          [FirstName] [varchar](50) NULL,
          [Lastname] [varchar](50) NULL,
          [Email] [varchar](50) NULL,
          [Company] [varchar](50) NULL,
          [Title] [varchar](50) NULL,
 CONSTRAINT [PK_Contacts] PRIMARY KEY CLUSTERED

After creating database, we create a new console application in Visual Studio

DapperExample.

Add an Application Configuration File in your project.

App.config

<?xmlversion="1.0"encoding="utf-8" ?>
<configuration>
  <configSections>
  </configSections>
  <connectionStrings>
    <addconnectionString="Server=MINDSTICKSERVER\MSSQLSERVER2014;Database=ContactDB;User Id=UserName; Password=Password;"name="DefaultConnectionString"providerName="System.Data.SqlClient"/>
  </connectionStrings>
</configuration>

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
 
namespace DapperExample
{
    classContacts
    {
        publicstring FirstName { get; set; }
        publicstring LastName { get; set; }
        publicstring Email { get; set; }
        publicstring Company { get; set; }
        publicstring Title { get; set; }
    }
}

Program.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Dapper;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
 
namespace DapperExample
{
    classProgram
    {
        
 
        staticvoid Main(string[] args)
        {
            var connectionString = ConfigurationManager.ConnectionStrings["DefaultConnectionString"].ConnectionString;
            Contacts x = newContacts();
            SqlConnection db = newSqlConnection(connectionString);
            string SqlString = "SELECT [FirstName],[LastName],[Email],[Company],[Title]FROM [Contacts]";
            var ourContacts = (List<Contacts>)db.Query<Contacts>(SqlString);
            foreach (var rec in ourContacts)
            {
                Console.WriteLine(newstring('*', 20));
                Console.WriteLine("First Name: " + rec.FirstName);
                Console.WriteLine("Last Name: " + rec.LastName);
                Console.WriteLine("Email " + rec.Email );
                Console.WriteLine("Company "+rec.Company);
                Console.WriteLine("Title " + rec.Title);
                Console.WriteLine(newstring('*', 20));
            }
            Console.Read();
        }
    }
}